package com.blueocean_health.care.management.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.blueocean_health.care.management.domain.base.NurseWorkerInfo;
import com.blueocean_health.care.management.domain.worktablevo.WorkersVo;
import com.blueocean_health.care.management.util.MyMapper;

public interface NurseWorkerInfoMapper extends MyMapper<NurseWorkerInfo> {

	@Select("SELECT nw.`id` AS workerId,nw.worker_name AS workerName FROM nurse_worker_info nw WHERE nw.`has_disable` = 1 AND nw.`is_del` = 0 And nw.`hospital` =#{hospital} and nw.work_status != 4")
	List<WorkersVo> getAllWorkersByHospitalId(@Param("hospital")String hospital);
	
	/**
	 * 通过护工编号查询主表护工数据
	* @Title: selectMainByWorkerId
	* @param workerId
	* @return
	* NurseWorkerInfo
	* @version V1.0.7
	* @throws
	 */
	NurseWorkerInfo selectMainByWorkerId(String workerId);

}